RowID: it is a fixed (never change), alpha-numeric, 18 digit number generated for every rows in the table.
It will never change based on insertion/deletion/updation.

Q: How to see the RowID for the EMP table?
Ans: select ename, job, sal, deptno, rowid from emp;


Q: How to find the duplicate records using rowID?
Ans:
select * from student where rowid not in(select min(rowid) from sample group by ID, NAME, CITY, AGE);


select * from student where rowid not in(select max(rowid) from sample group by ID, NAME, CITY, AGE);



Q: How to remove the duplicate records?
Ans:
delete from (select * from student where rowid not in(select max(rowid) 
from student group by ID, NAME, CITY, AGE));


